<?php
//############################################
//Now import the settings
include_once("settings.php");

//############################################
//Connect to the db
mysql_connect($db_host,$MySqlUN,$MySqlPW);
@mysql_select_db($database) or die( "Unable to select databases");

$query = "Insert into products values (
		  '00001','CBA Logo T-shirt',
		  'This T-shirt will show off your CBA connection. Our t-shirts are high quality and 100% preshrunk cotton.',
		  17.95,'2004-08-01'),
		  ('00002','CBA Bumper Sticker',
		  'Let the world know you are a proud supporter of the CBA Website with this colorful bumper sticker',
		  5.95,'2004-08-01'),
		  ('00003','CBA Coffee Mug',
		  'With the CBA logo looking back at you over your morning cup of coffee, you\'re sure you have a grt start to your day',
		  8.95,'2004-08-01'),
		  ('00004','Superhero Body Suit',
		  'We have a complete selection of colors and sizes for you to choose from. This body suit is sleek, stylish and won\'t hinder your crime-fighting or evil scheming abilities.',
		  99.95,'2004-08-01')";
		  
		  $result = mysql_query($query) or die(mysql_error());
		  echo "Products added successfully";
		  
?>